1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="hospitalDataSet1" targetNamespace="http://tempuri.org/hospitalDataSet1.xsd" xmlns:mstns="http://tempuri.org/hospitalDataSet1.xsd" xmlns="http://tempuri.org/hospitalDataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="hospitalConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="hospitalConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HospitalManagementSystemCSharp.Properties.Settings.GlobalReference.Default.hospitalConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="patientTableAdapter" GeneratorDataComponentClassName="patientTableAdapter" Name="patient" UserDataComponentName="patientTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="hospitalConnectionString (Settings)" DbObjectName="dbo.patient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[patient] WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gen = 1 AND [gen] IS NULL) OR ([gen] = @Original_gen)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_date = 1 AND [date] IS NULL) OR ([date] = @Original_date)) AND ((@IsNull_cont = 1 AND [cont] IS NULL) OR ([cont] = @Original_cont)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_disease = 1 AND [disease] IS NULL) OR ([disease] = @Original_disease)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_building = 1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cont" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cont" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cont" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cont" SourceColumnNullMapping="false" SourceVersion="Original" />
28 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
30 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disease" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="true" SourceVersion="Original" />
31 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Original" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
34 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
35 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_building" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="true" SourceVersion="Original" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Original" />
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
42 </Parameters>
43 </DbCommand>
44 </DeleteCommand>
45 <InsertCommand>
46 <DbCommand CommandType="Text" ModifiedByUser="false">
47 <CommandText>INSERT INTO [dbo].[patient] ([Id], [name], [gen], [age], [date], [cont], [addr], [disease], [status], [r_type], [building], [r_no], [price]) VALUES (@Id, @name, @gen, @age, @date, @cont, @addr, @disease, @status, @r_type, @building, @r_no, @price);
48 SELECT Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r_no, price FROM patient WHERE (Id = @Id)</CommandText>
49 <Parameters>
50 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
51 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
52 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Current" />
53 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Current" />
54 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
55 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cont" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cont" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
63 </Parameters>
64 </DbCommand>
65 </InsertCommand>
66 <SelectCommand>
67 <DbCommand CommandType="Text" ModifiedByUser="false">
68 <CommandText>SELECT Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r_no, price FROM dbo.patient</CommandText>
69 <Parameters />
70 </DbCommand>
71 </SelectCommand>
72 <UpdateCommand>
73 <DbCommand CommandType="Text" ModifiedByUser="false">
74 <CommandText>UPDATE [dbo].[patient] SET [Id] = @Id, [name] = @name, [gen] = @gen, [age] = @age, [date] = @date, [cont] = @cont, [addr] = @addr, [disease] = @disease, [status] = @status, [r_type] = @r_type, [building] = @building, [r_no] = @r_no, [price] = @price WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gen = 1 AND [gen] IS NULL) OR ([gen] = @Original_gen)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_date = 1 AND [date] IS NULL) OR ([date] = @Original_date)) AND ((@IsNull_cont = 1 AND [cont] IS NULL) OR ([cont] = @Original_cont)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_disease = 1 AND [disease] IS NULL) OR ([disease] = @Original_disease)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_building = 1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)));
75 SELECT Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r_no, price FROM patient WHERE (Id = @Id)</CommandText>
76 <Parameters>
77 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
78 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
79 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Current" />
80 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Current" />
81 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
82 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cont" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cont" SourceColumnNullMapping="false" SourceVersion="Current" />
83 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
84 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Current" />
85 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
86 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Current" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
89 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
90 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
91 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
92 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
93 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="true" SourceVersion="Original" />
94 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Original" />
95 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="true" SourceVersion="Original" />
96 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Original" />
97 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="true" SourceVersion="Original" />
98 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
99 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cont" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cont" SourceColumnNullMapping="true" SourceVersion="Original" />
100 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cont" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cont" SourceColumnNullMapping="false" SourceVersion="Original" />
101 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
102 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
103 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disease" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="true" SourceVersion="Original" />
104 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Original" />
105 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
106 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
107 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
108 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
109 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_building" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="true" SourceVersion="Original" />
110 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Original" />
111 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
112 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
113 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
114 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
115 </Parameters>
116 </DbCommand>
117 </UpdateCommand>
118 </DbSource>
119 </MainSource>
120 <Mappings>
121 <Mapping SourceColumn="Id" DataSetColumn="Id" />
122 <Mapping SourceColumn="name" DataSetColumn="name" />
123 <Mapping SourceColumn="gen" DataSetColumn="gen" />
124 <Mapping SourceColumn="age" DataSetColumn="age" />
125 <Mapping SourceColumn="date" DataSetColumn="date" />
126 <Mapping SourceColumn="cont" DataSetColumn="cont" />
127 <Mapping SourceColumn="addr" DataSetColumn="addr" />
128 <Mapping SourceColumn="disease" DataSetColumn="disease" />
129 <Mapping SourceColumn="status" DataSetColumn="status" />
130 <Mapping SourceColumn="r_type" DataSetColumn="r_type" />
131 <Mapping SourceColumn="building" DataSetColumn="building" />
132 <Mapping SourceColumn="r_no" DataSetColumn="r_no" />
133 <Mapping SourceColumn="price" DataSetColumn="price" />
134 </Mappings>
135 <Sources />
136 </TableAdapter>
137 </Tables>
138 <Sources />
139 </DataSource>
140 </xs:appinfo>
141 </xs:annotation>
142 <xs:element name="hospitalDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="hospitalDataSet1" msprop:Generator_UserDSName="hospitalDataSet1">
143 <xs:complexType>
144 <xs:choice minOccurs="0" maxOccurs="unbounded">
145 <xs:element name="patient" msprop:Generator_TableClassName="patientDataTable" msprop:Generator_TableVarName="tablepatient" msprop:Generator_TablePropName="patient" msprop:Generator_RowDeletingName="patientRowDeleting" msprop:Generator_RowChangingName="patientRowChanging" msprop:Generator_RowEvHandlerName="patientRowChangeEventHandler" msprop:Generator_RowDeletedName="patientRowDeleted" msprop:Generator_UserTableName="patient" msprop:Generator_RowChangedName="patientRowChanged" msprop:Generator_RowEvArgName="patientRowChangeEvent" msprop:Generator_RowClassName="patientRow">
146 <xs:complexType>
147 <xs:sequence>
148 <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
149 <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
150 <xs:simpleType>
151 <xs:restriction base="xs:string">
152 <xs:maxLength value="50" />
153 </xs:restriction>
154 </xs:simpleType>
155 </xs:element>
156 <xs:element name="gen" msprop:Generator_ColumnVarNameInTable="columngen" msprop:Generator_ColumnPropNameInRow="gen" msprop:Generator_ColumnPropNameInTable="genColumn" msprop:Generator_UserColumnName="gen" minOccurs="0">
157 <xs:simpleType>
158 <xs:restriction base="xs:string">
159 <xs:maxLength value="50" />
160 </xs:restriction>
161 </xs:simpleType>
162 </xs:element>
163 <xs:element name="age" msprop:Generator_ColumnVarNameInTable="columnage" msprop:Generator_ColumnPropNameInRow="age" msprop:Generator_ColumnPropNameInTable="ageColumn" msprop:Generator_UserColumnName="age" minOccurs="0">
164 <xs:simpleType>
165 <xs:restriction base="xs:string">
166 <xs:maxLength value="50" />
167 </xs:restriction>
168 </xs:simpleType>
169 </xs:element>
170 <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" minOccurs="0">
171 <xs:simpleType>
172 <xs:restriction base="xs:string">
173 <xs:maxLength value="50" />
174 </xs:restriction>
175 </xs:simpleType>
176 </xs:element>
177 <xs:element name="cont" msprop:Generator_ColumnVarNameInTable="columncont" msprop:Generator_ColumnPropNameInRow="cont" msprop:Generator_ColumnPropNameInTable="contColumn" msprop:Generator_UserColumnName="cont" minOccurs="0">
178 <xs:simpleType>
179 <xs:restriction base="xs:string">
180 <xs:maxLength value="50" />
181 </xs:restriction>
182 </xs:simpleType>
183 </xs:element>
184 <xs:element name="addr" msprop:Generator_ColumnVarNameInTable="columnaddr" msprop:Generator_ColumnPropNameInRow="addr" msprop:Generator_ColumnPropNameInTable="addrColumn" msprop:Generator_UserColumnName="addr" minOccurs="0">
185 <xs:simpleType>
186 <xs:restriction base="xs:string">
187 <xs:maxLength value="50" />
188 </xs:restriction>
189 </xs:simpleType>
190 </xs:element>
191 <xs:element name="disease" msprop:Generator_ColumnVarNameInTable="columndisease" msprop:Generator_ColumnPropNameInRow="disease" msprop:Generator_ColumnPropNameInTable="diseaseColumn" msprop:Generator_UserColumnName="disease" minOccurs="0">
192 <xs:simpleType>
193 <xs:restriction base="xs:string">
194 <xs:maxLength value="50" />
195 </xs:restriction>
196 </xs:simpleType>
197 </xs:element>
198 <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
199 <xs:simpleType>
200 <xs:restriction base="xs:string">
201 <xs:maxLength value="50" />
202 </xs:restriction>
203 </xs:simpleType>
204 </xs:element>
205 <xs:element name="r_type" msprop:Generator_ColumnVarNameInTable="columnr_type" msprop:Generator_ColumnPropNameInRow="r_type" msprop:Generator_ColumnPropNameInTable="r_typeColumn" msprop:Generator_UserColumnName="r_type" minOccurs="0">
206 <xs:simpleType>
207 <xs:restriction base="xs:string">
208 <xs:maxLength value="50" />
209 </xs:restriction>
210 </xs:simpleType>
211 </xs:element>
212 <xs:element name="building" msprop:Generator_ColumnVarNameInTable="columnbuilding" msprop:Generator_ColumnPropNameInRow="building" msprop:Generator_ColumnPropNameInTable="buildingColumn" msprop:Generator_UserColumnName="building" minOccurs="0">
213 <xs:simpleType>
214 <xs:restriction base="xs:string">
215 <xs:maxLength value="50" />
216 </xs:restriction>
217 </xs:simpleType>
218 </xs:element>
219 <xs:element name="r_no" msprop:Generator_ColumnVarNameInTable="columnr_no" msprop:Generator_ColumnPropNameInRow="r_no" msprop:Generator_ColumnPropNameInTable="r_noColumn" msprop:Generator_UserColumnName="r_no" minOccurs="0">
220 <xs:simpleType>
221 <xs:restriction base="xs:string">
222 <xs:maxLength value="50" />
223 </xs:restriction>
224 </xs:simpleType>
225 </xs:element>
226 <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" minOccurs="0">
227 <xs:simpleType>
228 <xs:restriction base="xs:string">
229 <xs:maxLength value="50" />
230 </xs:restriction>
231 </xs:simpleType>
232 </xs:element>
233 </xs:sequence>
234 </xs:complexType>
235 </xs:element>
236 </xs:choice>
237 </xs:complexType>
238 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
239 <xs:selector xpath=".//mstns:patient" />
240 <xs:field xpath="mstns:Id" />
241 </xs:unique>
242 </xs:element>
243 </xs:schema>
